package com.ruoyi.system.mapper;

import com.ruoyi.common.json.JSONObject;
import com.ruoyi.system.domain.PivotRequest;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @fileName: AlpWeeklyMapper
 * @description: TODO
 * @author: Li Wenbo
 * @date: 2020-3-2 14:47
 * @version: V1.0
 */
@Repository
public interface AlpWeeklyMapper {
    List<Map> getTotalWeeklyList();
    List<Map> getDeptWeeklyList(String deptName);
    List<Map> getPersonalWeeklyList(String personName);
    List<Map> getContractWeeklyList(String contractName);
    List<String> getAllXsName();
    List<String> getAllDeptName();
    List<String> getAllContractName();
    List<Map> getWeeklyBudgetPivotTable(PivotRequest pivotRequest);
    List<Map> getWeeklyPredictPivotTable(PivotRequest pivotRequest);
    List<Map> getWeeklyActualPivotTable(PivotRequest pivotRequest);
    List<Map> getContractWeekly(Map map);

}
